﻿ALTER TABLE [LogoDetail]
ADD [Tags] Varchar(500) NULL


GO

ALTER TABLE [LogoDetailDetail]
ADD [Description] Varchar(500) NULL

GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_LogDetailInsert]
			@Id int OUTPUT,
			@MenuId int
           ,@LogoInformationId int
           ,@NoOfFilePerPage int
		   ,@Tags varchar(500)
AS
BEGIN
	INSERT INTO [dbo].[LogoDetail]
           ([MenuId]
           ,[LogoInformationId]
           ,[NoOfFilePerPage]
			,[Tags])
     VALUES
           (@MenuId
           ,@LogoInformationId
           ,@NoOfFilePerPage
			,@Tags)

	SET @Id = SCOPE_IDENTITY()


END

GO


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_LogoDetailDetailInsert]
	@LogoDetailId int 
           ,@OrderNo int
           ,@FileName varchar(200)
			,@Description varchar(500)
AS
BEGIN
	INSERT INTO [dbo].[LogoDetailDetail]
           ([LogoDetailId]
           ,[OrderNo]
           ,[FileName]
			,[Description])
     VALUES
           (@LogoDetailId
           ,@OrderNo
           ,@FileName
			,@Description)




END


